---
title: XlPivotFieldOrientation Enumeration (Excel)
ms.prod: excel
api_name:
- Excel.XlPivotFieldOrientation
ms.assetid: 8dd82d0c-370a-464f-e666-5bc8cbcdacb4
ms.date: 06/08/2017
---


# XlPivotFieldOrientation Enumeration (Excel)

Specifies the location of the field in a PivotTable report.



|**Name**|**Value**|**Description**|
|:-----|:-----|:-----|
| **xlColumnField**|2|Column|
| **xlDataField**|4|Data|
| **xlHidden**|0|Hidden|
| **xlPageField**|3|Page|
| **xlRowField**|1|Row|

